shoot (yourself) in the foot

Translations
навредить (себе) собственными действиями
By lying to his boss, he really shot himself in the foot.
Солгав своему начальнику, он действительно навредил себе.
Definitions
To unintentionally make a situation worse for yourself, often by making a mistake or poor decision that harms your own interests.